www.loanperformer.com

Table of Contents (Online Help)

Importation of Savings Transactions

If you've been using another financial software product, and you'd like to import savings transactions from that product into Loan Performer, you can do so if that product allows you to export to a spreadsheet, dBase or text file. Savings transactions can be imported in three file formats, i.e., dBase, Microsoft Excel or Tab delimited text files. Each of these files has a standard file format on how data should be arranged. You can import the different savings transactions for the Individuals, Businesses, and Groups or Group members. The file structure is the same for all types of savings imports for each client category.

You have to populate the templates with your own data for the Savings Transactions before you import it. You can refer to the Savings Importation for further information regarding how the templates should be filled.

The savings transaction templates can be downloaded from http://www.loanperformer.com/Download/import.rar or got from the Loan Performer working folder under the import file folder, e.g., "C:\LPF81204\External Files\Import" . It will be under the file name Groups and Individual Savings and it looks like the one below:

Note also that when you hover the mouse over the column header, you will get more information about the column data.

• Account No: Enter the client account number to which you would like to import the Savings Transactions to. For a demo database, it begins with DB/I/.... (DB stands for Demo database, then after the slash we have the type of client I=individual and G=group and lastly the clients number).
• Member No.: This field is used for the member’s number if the option for Tracking of savings at group member level is enabled at Configuration->Savings.
• Date: This is the transaction date of the savings transaction. The transactions must be imported in chronological order with the oldest appearing first in the list.

Importation of data from Microsoft Excel requires that either the date is entered just as a date, e.g., "02/02/2014" – which is only suitable if you have only one transaction per day – or that it is formatted as a date/time field as follows: dd/mm/yyyy:hh:mm:ss in order to allow the time differences.

• Type: Enter the transaction type, whereby D=Deposit and W= Withdraw.
• Mode: This stands for the method used for payment for the Savings . i.e. 1=cash, 2=Cheque, and 3=other.
• Voucher No: Enter the voucher number that may have been issued or received for the Savings Transactions.
• GL A/C: This is the general ledger account of the bank/cash account where the transactions are booked

N.B: This voucher field is only compulsory if you checked the option "Voucher number is compulsory for entry of transaction" so be careful about the settings at menu System->Configuration->Register Part 2.

When all the necessary details have been entered, save the details and then the template is ready for importation.

Related Topics

Contact LPF live support for more information
This service requires an Internet connection.